Lived in the Charlotte area for a few years.
Around Charlotte: Whitewater Center with the kids is super fun. Hiking, kayaking and can white water raft. Olde Mecklenburg is a fun brewery with a big outdoor area. Other fun breweries are Sycamore and Noda. Lake Norman has a ton of water activities.
Just outside of Charlotte: Asheville and Hendersonville were our two favorite mountain towns. We always rented an airbnb and was able to hike/explore the mountains. Downtown Greenville, SC is a blast also.
If you want to get out of Charlotte, Charleston and Savannah were our favorite getaways. About 3-3.5 hours from Charlotte.
Have fun!