Please tell me which tool I have to use to create a video? I want to create a video as in the link below, the effect I want to create is that of a camera moving over a collection still photos and briefly pausing on each one:

Youtube Link to video - iit Madras saarang teser 2009 - India

Can anyone suggest me which tool I can use to create such video??
I have some images only. How can I achieve this kind of path navigation effect? 

PS: Provide some video links created by those tools you are suggesting, so that I can close this Question based on that (and upvotes).

UPDATED : QUERY ON AN EFFECT IN ABOVE LINKED VIDEO
Hi all thanks for the help. I am good with after effects, its nice. In between I want to know one more thing how can I create an effect as in the above video (39th sec to 41st sec), transition from one plane to another, is there any special name for these kind of effect??
After Effects could certainly do what you want, as could Apple Motion (only for Macs though). If you're on a budget you might want to look at something lower cost - or free:


Natron is an open source free compositor, that will be able to do that effect
Blender - as well as being a 3D animation package it has a compositor too 


compositing is the technique of combining images and video, so if you want to research more, what you need to search for is compositing software.