what is the best software for mixing video and images with special effects.

I have seen finished presentations with mixed video and still images, where there is a small video running in the corner of the screen while images are dispayed with special effects below etc etc.

Wondered what the best.easiest software to giive this presentaion variety

Thanks