Thank you for the responses. I have been to Dan Nicholas Park once for my niece's birthday party. It rained that day so I wasn't able to venture out but it seems like a nice park.
I think I have found the perfect campground! I have never heard of it before & saw a friend of mine who posted pictures of her recent trip there. Its called Jellystone Park in Marion.
Family Camping in NC | North Carolina Campgrounds | Yogi Bear's Jellystone Park Although its 2 hours from where I lived its still not a bad drive. Its privately owned & there's tons of activities for the kids. My friend said there's different activities every 2 hours. This place stays booked during the Summer so our camping trip will have to be next year. Besides that I love Yogi & Boo Boo Bear! I watched that show all the time as a kid.