You will need either a free FireWire port or video card with video input (RCA/S-Video) or a dedicated capture card depending on your camera's outputs.
For software it depends on your budget and platform. If on the Mac then use either Final Cut Express, Final Cut, Final Cut Pro or Avid Express DV. If on the PC use Adobe Premiere Pro, Sonic Foundry Vegas Pro, or Avid Express DV. I would suggest to try Vegas first as it is the cheapest of the three.