What display card are you using right now? Any card that shipped in a PowerMac G5 should be able to drive a 23" Apple Cinema Display. The two most basic cards for the G5 were the 64MB Radeon 9600 Pro and 64MB GeForce 5200. Both have dual display support and can drive every LCD on the market except the 30 incher. If you have one of those cards you're fine.
But if you are still shopping...
The Apple Store (and retailers like
OWC) have three ATI video cards available:
Radeon X800XT $399 - very high performance, but not cheap.
Radeon 9800 Pro 256MB $299 - good all-round performance, somewhat cheaper.
Radeon 9600 Pro 256MB $199 - good performance for non-gaming users.
All three will happily drive a 23" display. The 9600 (and in a few cases, like Doom 3, the 9800) will suffer with newer games.
There are several other cards that are good choices but no longer available new:
Radeon 9800XT - fairly rare, slightly better performance than the 9800 Pro. Was a BTO (build to order) option on some G5s.
GeForce6800 Ultra - Performance equal to the X800XT. Can drive up to two 30" displays. Another discontinued BTO card. (it also blocks the adjecent PCI-X slot due to its huge fan).
GeForce6800GT - Very high performance, close to the Ultra in performance but can only drive one 30" display.
These three can be found on the used market but will not necessarily be substantially cheaper than the X800XT or 9800 Pro. All three of these will happily drive a 23" display.