I would probably get one of those miniDV cameras or whatever the modern equiv is (I have one of those sony mini dv cameras - got it years ago - has forewire on it.). Basically anything that can dump the resulting video out over firewire to an editing application. For filing you own stuff, particaular in a club setting, you will want something with good low light response, ant-flaring (from lights) and probably good auto-image steadying to go with it. Good low light repsonse is the kind of thing that separates a cheapo camera from an apparently feature similar expensive camera, along with lens quality etc. If you need zoon - get the best optical zoom you can as digital zoom is a pixely hack.
Windows Movie Maker is a reasonable free starting point for editing, obviously there are way better commercial applications around, but this is probably allready on you PC as part of the windows XP install. It can communicate with Firewire cameras to do the download from the camera.
If you want to do sync work, then Live 6 may help, but probably only audio to video sync, not the other way around - Ive not tried this.
Once you have done you movie in whatever application, then you need to export it in a resolution and format suitbale for youtube - Im sure they provide details of the upload format requirements.
It could be worth posting this on the Ableton forums if you are looking for tools to manipulate video in time with music - probably loads of people their who have done it.
Im way ot of touch with the options avalable these days TBH - ask me this 15 years ago - and would have been a differnt story - used to do video work for a living - not much help now
