First a video camcorder your choice. Then I have been using Corel Ulead DVD MovieFactory 5.6 it came with my new Canon HG10 but I am sure you can get a copy from Corel.
It's not a real powerful program but it will give your good results quickly without over powering you with details.
Harry Palmer made a great Making A Movie - A Tutorial found at
Camcorderinfo.com Message Board - Making A Movie - A Tutorial
If you follow his tutorial you will find it's very simple to be making and editing a movie.