for that, a 5870 / GTX 470 or upwards will do that. If you're worried about future upgrades, you can go SLI later, once the cards get cheaper and the games more demanding.
Basically, I'd just go for a Intel / NVIDIA single card, with option of SLI later on (or the latest single card at the time if it proves to be competitive with 470 x 2).