Some Corps of Engineers parks and state parks have sites that back up to a body of water for a beautiful view out the back window. A few that come to mind are Seven Points COE near Nashville, R. Schaffer Heard on West Point Lake in Georgia, Winfield COE and Petersburg COE in Appling, Georgia, Maumelle COE in Little Rock, Cranes Mill COE on Canyon Lake, Texas.
A few private parks have great views out the back window. Tom Sawyer RV Park in West Memphis, Arkansas has sites for fifth wheels that are designed so you have a view of the Mississippi River out your back window. We were in a back in site with a view of the bay at Baycrest RV Park in Homer, Alaska.
When making reservations in federal campgrounds including COE, you can look at a map a choose a site on the water. Some state parks also have that option.
You can also look at photos of many campsites at
CampsitePhotosEnjoy the view!