Along most major rivers and lakes there will be RV parks with sites that overlook the water. What I do is decide what river or lake I would like to visit then use www.rvparkreviews.com to locate RV Parks in the area using the map on the website you can see if the park is at the river or lake. Then go to the park website to see the photos...if I see photos of RVs in sites on the river bank or shoreline then that's the park that goes on my list. Check reviews to determine which park on the list I want to try first.
Here's a couple of my favorites in California
Edison Campground, Shaver Lake, CA. In the western Sierra Mountains.
Sequioa RV Ranch, near Three Rivers, CA. on the Kaweah River & a good base camp for visiting Sequioa and Kings National Parks. Site 55 is our favorite http://www.sequoiarvranch.com/campground-map.html
In Michigan near Coldwater is
http://www.wafflefarm.com/ Beautiful grounds and lakeside sites.
