I think the Locust Fork is II - III-, and there's a really good surf wave down near Eufaula or Wetumpka, somewhere over on that side of the state not too far from you.
Hopefully some more folks from the SE will chime in with info - it usually happens right after someone puts up a post saying that MB is a Colorado only website.
Check out Alabama Outdoors in Pelham, there's also a UA kayak club
in Tuscaloosa. The UA club website has phone numbers for their leaders - give one a call and do some google searching.
Good luck and keep the questions coming!