Gulf Shores State Park CAMPGROUND is actually on a LAGOON, not any real body of water. Driving to the beach is your only option. Also, it's a large campground so depending on your site location, you may have to drive to the pool also. The last thing is the alligators. Being on a lagoon, they will visit your campsite. We had two that loved our BBQ and would visit every night. Eliminates leaving your dog anywhere outside the coach. Probably would be the same with your toddlers. The do have signs posted advising your it's against the law to tease or aggravate the gators.
An alternative would be Henderson State Beach in Destin...about 2 hours away but within walking distance of the beach. Free alligator farm within walking distance, a WalMart and other kiddie stuff right there....good luck...Dennis