First off, congratulations to your husband. Duke and Wake are both fantastic schools. But I have to tell you, if you're husband's going to be going to Duke or Wake Forest, Winston-Salem is probably out of the question. Your're looking at a 1.5-2 hour commute to Duke and even longer to Wake Forest. It's really in a different region of NC altogether.
Having said that, personally, I would base the decision on which school you decide on. Raleigh is much more convenient to Wake Forest and Duke is actually in Durham. Either place would be a great place to live, both with downtown areas going through a renaissance and plenty of shopping, restaurants, recreation, etc...
Raleigh has a GREAT farmer's market. As the state capital, it plays host to the NC Dept of Agriculture State Farmer's Market NCDA&CS - Marketing Division - Raleigh Farmers Market
. Good luck in your search!
-- Jason Fant