All G5s take SATA drives. There are two internal bays. The optical drive is PATA, and if you replace the cable, it is possible to put a 3rd HD (PATA) on top of the optical drive.
The max drive size you can fully use is 2 TB. This is a limitation of the Apple Partition Map which G5s use to boot from. You can install a 3 TB drive and partition it with GUID. It will mount as a data drive after bootup, but will not boot.