Like the others have said, their are plenty of lakes and ponds around Raleigh. You might try Falls Lake, Lake Jordan, Shelley Lake, Lake Len(if you'll put up with carp), Lake Harris, Lake Wheeler and Lake Benson.
The one I have the most experience with is Shelley lake(really a pond) they have some pretty nice Cat Fish, lots of [small] bluegill, and I've been told some Bass as well.
There are also several ponds in housing developments you might want to try out.....I know of several but my mind is drawling a blank and I can't think of the names right now. I'll get back with you when I remember.
Gray