That's great that you'll be moving to the area soon! North Raleigh is also a really nice area. I just bought a new place and live in NW Raleigh now, but must admit to missing N. Raleigh and all of it's conveniences (close to everything in Raleigh).
The Tarheel Boxer Club meets in Apex once a month. Apex is near Cary. I must admit to missing all meetings since October (oops), but they are nice folks and have good speakers on a variety of topics. You can even take your Boxer to meetings. For info, plug the name of the club into google.
Other stuff...if you are into music, there are very nice outdoor concerts at Regency Park in Cary and Walnut Creek Amphitheatre in Raleigh. The NC Museum of Art also has outdoor movies on the lawn and concerts through early Sept. The Glenwood South area of Raleigh (near Glenwood and Peace streets) is kind of an in place to go for dinner if you are in Raleigh. There are a lot of new and very good restaurants. In NE Raleigh, the new mall, Triangle Town Center, has a number of good places to eat and shop. The Southpoint area in SW Durham, which is right off I-40 has many shops, the mall (Southpoint) and food options.
Chapel Hill is a another story altogether. The Franklin Street area (downtown) has lots of good restaurants. West Franklin seems to have the newer, more trendy places--West End Wine Bar and a restaurant called Lantern. Crooks Corner is a must try for those who are new to the south. The food is kinda nouveau southern cuisine and it's well-prepared. It's not ultra-pricey, but it isn't cheap. Best to have a reservation there and if it's nice out, they have a neat enclosed patio. Talking about patios, 411 West is a neat Northen Italian place in Chapel Hill (on West Franklin) and has a sister restaurant near Glenwood South (at Glenwood and West Jones Streets) called 518 West. They have good food. Both have nice bars (a tiny bit upscalish--if upscalish is a word!).
With regard to craft-type stuff, Cary has Lazy Days in late August, I believe. I went last year and it was hot as H**L! There are all types of folks their selling nice crafts. CH also has a similar thing, but not quite as nice. It's held twice a year and is called Festifall in October and Apple Chill in April. Raleigh has it's own crafts "fair" in lat May called Artsplosure. There is some really nice stuff there.
Raleigh also has First Friday when the art galleries at Artspace (in downtown) are open late on a Fri night once a month. It's interesting and very social. CH has something similar in CH/Carrboro.
There are dog parks in CH (off Homestead Road, which is off Airport Road, also known as MLK Road), Raleigh (off Springforest Road, at Millbrook Exchange Park), Durham (not sure where it is, but you must pay a yearly fee, I believe) and Cary. I'm not sure if the Cary DP is open yet. Best way to find info is to go to the respective departments of parks and recreation websites for directions. I believe the DP in Raleigh is nicest. It's in N. Raleigh and is a serious hike if you live anywhere besides N, NE, NW or downtown Raleigh. It has lights, though and is huge and well-maintained. It can be mobbed on nice weekend afternoons, so I would avoid it at those times.
The best resources for info on what's going on are as follows: The Independent and The Spectator, weekly publications that are kinda newsprint magazines. The I is usually kinda libeal and The S is at the other end of the spectrum. That said, both have info about activities/concerts/restaurants/festivals. The News & Observer (Raleigh paper) has a section called What's Up and I love it. It has movies, concerts, restaurant reviews, etc.
If you need a realtor, let me know. I have a wonderful realtor, though his area is primarily N. Raleigh.
Any more questions.........let me/us know!