The area around Cameron Village is fabulous. Cameron Village is the first "mall" built in the Southeast. I put "Mall" in quotes because it's not one of those large indoor monstrosities of today, but rather an outdoor pedestrian mall, built in the 1940s, with dozens of restaurants and hip, small shops. The surrounding area is made up of a mix of townhomes, condos and detached homes. It is also walking distance of Peace Street, which has additional shops, and leads to Glenwood South, the "hippest" part of Raleigh.
Durham is also has many neighborhoods that may meet your criteria. In many ways, Durham has "hipper" neighborhoods with an artsy flair. If you're planning to work in RTP, that may also be a worth considering.