Welcome to the site! You will be near Jordan Lake and Shearon Harris...both are very nice lakes for bass. Within an hour or two are many more lakes that have great bass fisheries and lots of fun to fish!
Peruse the Freshwater Fishing and Piedmont Reports sections, you'll find a number of posts about Raleigh area fishing. When you ask for pointers, the more specifics you give, the more people know what you're looking for and can help better... pond or lake? boat or bank? Paddling, trolling motor, or gas engine? distance you're looking to travel? There are lots of bass fishing opportunities in NC, so feel free to ask specifics in order to get specifics.