There is good deer/turkey hunting nearly statewide. There is public water all over the state, so there are always places to hunt waterfowl for everyone. Lake Eufuala is much larger than any of the water near Demopolis. As far as which one has the best waterfowl hunting, I'm sorry but I don't know the answer to that one. One thing to remember is that AL is between flyways, so duck hunting is often a real hunt to find where the birds are.
If you ever end up down towards Mobile, I can give you some pointers on places to start looking for birds, although each year is different.