Check out this online service. Animoto lets you import your pictures and your background music, and then it analyzes the pictures and music to create a custom video. This is pretty cool. I’ve typically used the free Microsoft Photostory or iPhoto to create slideshows, but this kicks it up a notch. The free service is limited to 30 seconds, but you can pay a small fee per video or per year for unlimited service.
This would be great for sharing pictures on your church website, especially for children’s and youth ministries. Check it out, and thanks to Tim for post. Here is a video that a youth pastor in Minnesota did for their youth mission trip.