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...
|Steamin' Mad by ahrensjt|
from Angered Subjects (Street Photography)
|Smile by Olymguy|
from Ultra Asian Indian Female Faces
|Space Shuttle Cockpit- by vbuhay|
from Aircraft Control Stick