C.F.
There is a campground attached to an amusement park...I don't think it's near water but I'm not certain. It's Knoebles Grove in Ennis, PA. My cousins went there every year growing up and now they bring their kids. Hope this helps or consider it as an option.
C.