Any video editor should be able to do that. You'll get the fades and blends and sparkly things as well because they'll all something someone needs and they are fairly easy to implement. Making "a window appear" involves resizing, moving and possibly cropping the individual video components, each of which is on a separate layer inside the one video frame and takes lots of processing power. It's not as easy as just "opening another window" on your desktop because you want the result in a single video frame.
Much has been said around here about the
Olive Video editor though it seems to be in quite early stages of development. It is certainly free.
I use
KDEnlive but my choice was influenced by it being available for Linux originally. It does work on Windows now, but I don't know how well.
A google search for free video editor will give you plenty of other ideas.