It would run CS: Source very smoothly. I had HL2, CS:source, and all that jazz and it ran at a super super smooth level with all the graphics settings maxed, AA and AF on, and 1680x1050 resolution.
You're computer will support this video card too.
Do you know how big your power supply is? I think it would manage it alright.