Ideally you want one that uses DV tapes. The video is digitally stored on to tape. Most camcorders (if not all) that use this technology include a firewire or USB out connection which allows you to capture the video on to your pc.
Your PC will need a firewire or USB (2.0) connection depending on the camcorder you buy.
You will only need a TV card if your camcorder has no such connection and you are then forced to use the normal TV out connections.
Dont forget you'll need some video editing software for your pc too!