If you can use military facilities, NAS Pensacola has a nice cg on Pensacola Bay as well as another site ,Blue Angel Campground on Perdido Bay. Fort Pickens CG has been closed since hurricane Ivan 2 years ago with no opening in sight. Grand Lagoon State Park has a CG with water access. There is a KOA in Lillian AL, right across the Perdido Bay bridge. Black Water River state park also has a cg. Thee are more around but these are the big name ones.
Make sure you see the Naval Aviation museam as well as the Blue Angel Practice at NAS every Monday and Tue. You sit on the sirfield and see the whole complete show, for free.
BillD