Here is a link to the resource that I use when looking for places to ride - we ride in NC, SC, TN, KY, and VA - these trail and campground reviews help alot when looking at new places! HorseTrailDirectory
In NC, Kings Mountain is nice and has a campground
For mountains - check out Moses Cone at Blowing Rock - gorgeous! The campground at Blowing Rock Equestrian Preserve is really nothing more than a big gravel parking lot, but there are stalls and water/elec hookups. Most find it worth it for the views there.
Someone recently told me that Medoc Mtn is nice, we are going to check it out soon.
When we travel far enough that we need to break up the trip, I use Horsetrip.com-An Online Overnight Stabling Directory for Horse Stabling and Horse Motels
to find a spot for us overnight.
If you want to see some great views and good camping, I recommend Hungry Horse East in VA, Land Between the Lakes in KY and TimberRidge Campground in TN. TimberRidge is great 5 star rating!
We go to H. Cooper Black in SC a couple of times a year - SUPER nice campground - wide, flat sandy trails - no mountains, tho!