Hey man. I actually did pretty much the same thing in a Compaq system. I got my girlfriend one for Christmas, upped the graphics to a 7900 GS. Had to do the PSU as well of course. It's the same motherboard and all. What I can definitely tell you is DON'T GET AN ANTEC NEOHE!!! It has many issues with Asus boards. I ended up getting a pretty cheap Ultra 400W PSU with 20A on the 12V rail.
That's all that really matters. For a 7900 GS, and probably for that ATI card too, you need at least 400W with 20A on 12V. Take a look at the specs on the box of the PSU. Sometimes there might be more than one 12V rail with an amperage value on each. If so, you can still figure the total amperage value for the 12V rail. You need to know total wattage for 12V. Divide that by 12. For instance, 384W/12V = 32A. So, just get something that's at least 400W and with a total of at least 20A on 12V, and you'll be good to go. You can also check out the PSU 101 sticky in this forum:
http://forumz.tomshardware.com/hardware/PSU-101-ftopict198276.html It's very informative.
Well built PSUs include Corsair, more recent Thermaltake models, OCZ, other Antecs, Enermax, Seasonic. I believe there's another sticky in the forum with a list of quality PSUs. Check Newegg out as they always have some good deals going on.