Mark's point about working out exactly what you are trying to produce is very well made. But assuming you are wanting to produce a DVD-resolution package, you could do a lot worse than downloading the free one that Microsoft produces for Windows.
It's called Photo Story 3 and you can download it from
http://www.microsoft.com/PhotoStory
I used it to produce
this video, made up from photos of two or three days at the Magic Kingdom. The music came from a Disney CD sold at the park. Note that this version is 800 pixels across, but you can ask for higher resolution from the package. Also, you can buy a DVD output plugin for, I think, around US$20.
I found this package interesting, but fundamentally flawed in that it was really hard to tailor slide transitions to match the rhythm of the music. So for my next attempt I used Son'y Vegas Movie Studio (a cut-down version of the professional Vegas Video tool). I was able to have much better control of the zooms, transitions and timing, and was able to fit them to the music. You can view that video
here.
I have learned from Photo Story that I could do with some better functions - the ability to get the program to make the picture show duration fit the music, for example. But it was well worth the download
regards,
/alan