There is some retention ponds I can share if you shoot me a message. You got to be willing to walk through some thick stuff to fish but there are fish. Also, chace lake in hoover has some fish, its small, highly pressured but easy to get to and access from the bank.
I would second the cahaba. You can walk it or find shore spots with some google searches. There are red eye and its fun to catch em. I haven't spent alot of time there but a buddy just moved to a house that backs up to it, we walked it once and caught a bunch of red eye bass through worms.