Last year we went on a camping trip to Newport, RI. There are several things to see there, eat and enjoy. One of the thing we did was to take a harbor cruise, here is the video I took and uploaded
Newport, RI harbor cruise
In addition to that you can take tour of mansions, awesome loop around scenic water view and there is a state park (small) with overlook of water, you can park there for whole day and enjoy the view.