(had a question pm'd to me from a parent who is applying that I thought might have a relevant answer to others...answer posted here)
As for the area being family friendly...Campbell itself is in the middle of nowhere, the area has a lot of nature/parks/trails etc. I like rural so it's perfect for me. The question of raising kids though involves schools. Assuming you can't afford private schools while one parent is not working that leaves public schools. Using the state of NC website for their grade level assesment tests, the public schools right around campbell (we were only looking at elementary) are pretty bad. Like 30% reading at grade level bad. It's odd to be 40miles from the highest concentration of PhDs in the country, the research triangle, and be that bad but it is what it is. What's nice though is there are a few very nice small towns in between campbell and the triangle that offer progressively better schools. Fuquay Varina is about 10miles up the road and the school s are about 10% in terms of kids reading on grade level if I remember right. Holly Springs is about 20 from campbell and they are in the 50-60%range if I recall. Partially for my wife's work and partially because the schools were approaching 70% reading at level, we decided to live in Apex. It's 30miles but I'm a dad, so my comfort isn't the only consideration. I'm just moving there this summer, but my wife's family is from the triangle and they can't get enough of NC. You can be at the beach or the mountains by lunch if you leave early and the seasons are mild compared to most the country. As a side note, you mentioned preschool, don't forget that while you are booked in class and you significant other is working preschool is one of the allowable reasons to increase your "cost of attendance" for FAFSA.
The other specifically nice thing about Campbell is what Dr. Kessler (in charge of 3-4yr rotations) is trying to set up. He's arranging pods of rotations so that students can avoid moving around much during yr 3-4 if they want. One pod will be there right around campbell, they are setting one up in raleigh, and he had plans to set one in western NC eventually for those that want a change of scenery. His concern for students with kids was one of the primary reasons for arranging this.