I'm using AutoGallery SQL and am very happy with it.
I'm a long time user and recently upgraded to the latest version. The new template system was a bit much to figure out but once I did I realized just how powerful it is.
It does all that you are asking for and a whole lot more.
