Good Times
Not sure you could go wrong with a site on the Woodsy Loop. All the campsites have easy access to the water, but not too close that you need to worry about little ones adventuring down to the water on their own. You can launch a SUP just a short walk to the water. If you want to fish be sure to grab a license in town. We stayed at campground #42 and were happy with it. The campground in general is very clean!
Site42
Month of VisitJune