u can use windows movie maker but the effect u can use is quite limited...but really easy for home use...

u can also check out for sony vegas, this one is also good for more effect use and multiple video layers...

might want to integrate with after effect...