Russel Peters Intro video
There is no specific title for this kind of video.

You can achieve what you want with any video editor that supports layers and masks. Adobe After Effects would be on solution.