There are several options -
Fotomagico has the best control over pan and zoom and has some titling options too ( http://www.fotomagico.com/ )
Photo to Movie ( http://www.lqgraphics.com/software/phototomovie.php ) renders output a little better (less movement artefacts with pan and zoom) and is also quite nice.
Photo Presenter ( http://www.arizona-software.ch/photopresenter/ ) uses OS X built-in animation capabilities and is very reasonably priced - the animations are gorgeous and rendering is top notch and fast, no titling capabilities though and little control about music.
I would try them all and decide for yourself.
P.S. You will need iDVD or Toast to actually author the final DVD with all of these...
|Madrid subway by MAGMATCICO62|
from Your City - Public Transport
|Incandescent Bulb by Kukla|
from Illuminate- Macro only
|Curiousity by PERCY2|
from Macro - Your Best Macro Ever
|Hoar Frosted Trees by sabishiT3T|