Yes, a Serial ATA drive would do the trick. You might want to consider an SSD if it's only going to be your system drive. I added one to my Mac Pro and it's a noticeable upgrade. 128GB works as long as you keep your system lean. Inside your Power Mac G5
New egg has pretty good prices.