u can can download the free version at www.flash-slideshow-maker.com it's easy to use.. and play with effects. but it can't play sound... maybe the upgraded version will do. hope it's usefull...
i recommend Microsoft Photo Story. Its a freeware that you can download from Microsoft. That is the best. The options to zooming/panning of the photos and all are easy.
I just used it recently for a friend's wedding video.
in the Flash program itself you can make a presentation for picture gallery there is many ways you can make them with... i know how but how to write it here for you !!
The example you've given is quite the site.
Lots of movie clips and animations.
I like it but it's pretty intensive to build
SimpleViewer has a nice simple interface and it's free (no music tho)
SlideShowPro is a really nice interface that works with Flash MX2004 and Flash 8 and it's pretty cheap. It has an iPhoto plug in if you're on Mac OSX 4
iPhoto, iMovie and iDVD have some automated features that work great adding sound (if you're a Mac User)
Just a few to get you thinking.