The best schools in the area are considered, by many, to be those in Cary and in Chapel Hill. My husband teaches at Duke in Durham, so when we moved here we knew we'd be living in Chapel Hill., the best at the time. My suggestion is to look at the schools in both districts. Cary is part of Wake school district, many are served by local families, though I've heard that they've started going over to Briar Creek area (by bus) for middle school because one of them in Cary is overcrowded.
Honestly, I don't know as much about the Cary schools. I've been reading about the turmoil with Wake country schools for the past year, so check online to see where they are now. Both communities have a Whole Foods (big attraction when I moved to Chapel Hill though it was something else before being taken over by Whole Foods) and a Trader Joe's.
Congratulations on your job in RTP, not an easy coup these days.