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...
|I am an Elephant by Bibix|
from An A to Z of Subjects- Week 5, E
|Mossy forest panorama by Jill Hancock|
from Your point of view
|Ship Moon and Stars by LJJohnston|
from For creative newbies only..