Hmmmm....
Carrboro/Chapel Hill area is full of the arts, plus there's the Eno River for the nature people (I've never been so I can't provide more info). There's also Umstead Park in Raleigh thats really nice, Jordan Lake is close to all the cities. Raleigh is good too of course. Its pretty much the center of everything. Charlotte is about 3 hours away from Raleigh and its about an hour or so away from the mountains. The beach is about 2 hours away from Raleigh. Carowinds is located in Charlotte, thats always a plus for the kids. I think anywhere in the Triangle would be perfect. There is a school listing SOMEWHERE on the internet (I"m sure someone can direct you to it) that has the scores for the schools. Maybe find the ideal school and go from there? Honestly, you can't go wrong with anywhere you pick.
Trust me, I've lived here all my life!
Good luck!
Heather
Whoops!
Try this:
http://www.citysearch11.com