Source is a really picky and random engine when it comes to graphics cards. If you're going to buy an nvidia, and don't want to pay for an 8800, i'd recommend a 7600. For some reason, source works better with the 7600 than the 7900.
Also, I've heard that ati cards render source better, but I've never seen any proof of this. I still use nvidia.