[Halcyon]

Any camcorder or video device with a firewire connection should do you fine as long as your PC has a firewire port.

As for software Adobe Premiere and After Effects are probably your best choice for features and professional quality.
Premiere lets you arrange and cut up stuff accross a timeline and aftereffects well does what it says....effects and lets you mess around more with your video.