A 7900GS or GT should do what you want for now (very well) imo. Talking 150 - 225 dollar price range, give or take. Though like tiger said; a 8800GTS 320 is 300$ on the button, offering much more performance and longevity.
When I think of on-board video, libraries, offices, and public...