Check out the Rainbow Plantation in Summerdale, AL. One of the cheaper places to camp in Southern AL, especially if you are an Escapees RV CLub Member (membership is only $39/yr) See: https://escapees.com/support/parking/rainbow-parks/summerdale-Alabama
Lots to see and do in the area and the Plantation has planned activities as well as meals available on Tuesday & Thursday evenings & Saturday breakfast for very reasonable prices.
The Fish River is one mile away and you can put your kayak in there.