If you have iMovie it can import video from most camcorders, but not all. It comes with every Mac Pro. If you need to restore it from the original installer discs, these are the directions:
Typically iMovie can import if you connect via IEEE 1394 or USB. IEEE 1394 comes in three flavors:
4 pin (typical for many camcorders), 6 pin (known as bus powered Firewire 400), 9 pin (known as Firewire 800 or 1394b). Cables exist to connect each type of Firewire to each other. Locate your Camcorder directions on Sony's website to determine what pinout exists if you don't have the manual.
Double check on Sony's website there isn't a firmware update for compatibility with your operating system.
Push comes to shove, you may have to install Windows on your Mac to connect the Camcorder.