If schools are your priority, I agree with the previous poster. The southern fringe of suburbs in Birmingham really are the way to go. You really won't go wrong with Vestavia, Mountain Brook, or Homewood.
In fact, here is an article with links to a rundown of all the local schools and how well they tested at the various grade levels.
Alabama Reading and Math Test: Compare your schools - Reports from The Birmingham News - al.com
Personally, we are in the Mountain Brook school system. My older two children attend MBJH and my youngest attends Brookwood Forest. I am a great admirer of this school system, despite my initial doubts enrolling them here. The teaching, the facilities, and the commitment of parents is top-notch. I'm sure that Vestavia, Homewood and Hoover parents would say pretty much the same thing.
Good luck. Feel free to answer any other questions. We try to be a helpful board.