Roton Point is a nice spot.

New England 100 is fun, 2 days, starts and finish Quonset Point RI and goes around Jamestown Island, and other smaller islands in Narragansett Bay. You can camp and its usually in August.