Look at Carolina Beach State Park. It is a real nice facility located adjacent to the Cape Fear and Snows Cut. Good fishing there and a lot of activities for the kids. It is a few miles (4-5) from Fort Fisher.
if you qualify or have someone in the party that does, you can camp at the Fort Fisher Military Recreation Area. It is at Fort Fisher basically.
Google either and you can learn about them