I agree there's an attraction to water-side camping, but after many dry camps, I find I sleep better away from the water. Usually fewer people, fewer bugs, fewer animals after your food, lower humidity (less dew in the morning), and often warmer temps. I'll stop at that lake or river to clean up, stock up on water, take in the view, then leave and find a high, dry, breezy site to camp.