What PSU (Power Supply) should I get for my computer?

Hi all, my old PSU is fried and I want to get a better/reliable brand. I have a MSI N1996 motherboard and PATA hardrives (Seagate Barracuda 7200.10). I was thinking of going with a - Corsair 500CX ATX Power Supply Unit?