Your Mac should already have two programs that can do this -- iPhoto and iMovie, the latter being more flexible but of course takes more time. Frankly, I can't see buying any app just to do this task, but if you hate Apple I'm sure somebody will chime in with some third-party options.