Please tell me which tool I have to use to create a video?
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.