Isaac Creek Campground near Monroeville, Alabama is great
It's on the Alabama River next to the Claiborne lock and dam. That's the closest thing to a waterfall that there is, but the fishing is great. Campground includes sites with docks by the creek, two clean bathhouses, basketball court...