My wife and I drove through Rising Sun Campground on Friday 12 July. Nice, quiet campground. Some shaded sites, others open to the sun. At 2PM plenty of sites were available. This is a first come-first serve campground.
As for drinking water in the park, get yourself a Steri Pen and you will be able to drink at most creeks and rivers. I use mine all the time when hiking.