We took two different weekends at Piney Campground and both times were able to get waterside spots and drop the kayaks right in at the campsite.  There are a LOT of kids around riding bikes (so be careful driving) but people respect the campsites and do a good job of being good neighbors.  

The best spots book up quickly, especially for long weekends so reserve EARLY if you want a specific date.