Well, if your company's moving to Raleigh, that doesn't always mean you'd live in Raleigh. Depending on where your company is, you may end up living in Cary, Garner or Durham. I can tell you, if you're in Cary, a lot of the places to fish for cats are in the lakes that are near or in the town... to get to rivers, you'd have to drive a bit.
I reside in Cary, and I fish a lot in the Lochmere Lakes - two large man-made lakes that belong to a huge sprawling neighborhood development and Bass Lake which is about a 10-15 minute drive to Holly Springs.
If you end up living in Cary, you'd have to drive at least 30 minutes to get any where that the other guys talk about on this forum, as I found out myself when recommended other places.
Bass Lake has the most promising results, in quantity of hits and activity, than any of the other lakes I mentioned above, however, the Lochmere Lakes have bigger catfish... they just don't act up as much.
There's also Lake Jordan, which is fishable, and you can set up camp and trot lines, but still it's a bit of a drive. It's a favorite summer place for me, though. I haven't fished there yet, but I have camped and stargazed there in the past.
And lastly, there's Lake Johnson, it's technically in Raleigh, but it's so close to Cary that it isn't much a drive. It's actually right next to my high school... so yeah. People will tell you that you can fish for cats there, but I've tried on several occasions over the past 10 years I've lived here... You're not going to catch a catfish in there. It has a dam, and I haven't tried there, but every where else, no signs of catfish. It's more a bass fishing lake.
I hope this helps.