Thank you both for the information. 
My apologies. I meant Power Mac.
Out of curiosity do you think that I would be able to use a basic SAT3 SSD at SATA2 speeds on the 2005 Power Mac?
Is it a closed loop water cooler for just the CPU sort of like this?
If I buy one with 2GHz or more it will have two processors? What is the highest speed air cooled G5 processor?
You are mixing models.
There is no such thing as a G5 Mac Pro. It's either a PowerMac G5 which has a PowerPC processor or a Mac Pro which has an Intel processor.
The Quad PowerMac G5, the Mac under discussion, is only capable of Leopard 10.5.8 max. Just so you are aware of that.
I believe the max ram is 16GB and SATA 2 is as good as you can get. Some SATA 3 drives will be recognized, but not all of them and there tends to be problems.
The PowerMac G5 is the only model of PowerPC Mac that has SATA natively.
My apologies. I meant Power Mac.
Out of curiosity do you think that I would be able to use a basic SAT3 SSD at SATA2 speeds on the 2005 Power Mac?
There were effectively two "generations" of the G5-the original models that used AGP graphics, and the late '05 models that used PCIe graphics and had a bunch of other changes. The above listing of GPUs is only applicable to the late '05 models.
The AGP computers came with either one or two processors with speed ranging from 1.6ghz to 2.7ghz. As far as I'm aware, anything above 2ghz was dual processor, and anything above 2.5ghz was liquid cooled. If you're buying a dual 2.5 or dual 2.7, look for signs of liquid leaking very carefully, as these are a known trouble spot. The max ram for lower end models was 4gb, while most higher end models maxed at 8gb. These used DDR PC3200 RAM.
The late '05 models used the 970MP processor, a dual CORE version of the G5. These came in a 2.0 dual core, 2.3 dual core, and 2.5 quad core. The last is what's collectively referred to as a "quad." The Quad has two dual core 2.5ghz processors. It is also liquid cooled, but the cooling system is generally pretty reliable.
The late '05 models take DDR2 PC2-4200. They have 8 slots for a maximum of 16gb of RAM.
All G5s have two 3.5" hard drive bays for SATA hard drives. Boot drives must be formatted HFS+/APM, which limits the maximum partition size to 2TB. GUID can be used for non-booting drives, which gives you more flexibility. There can be issues with SATA III drives, but SATA I and SATA 2 are fine. The optical bay has a single slot for an IDE drive, but the IDE bus can support a hard drive if you want to shoehorn one in.
Is it a closed loop water cooler for just the CPU sort of like this?
If I buy one with 2GHz or more it will have two processors? What is the highest speed air cooled G5 processor?