The Sapphire 7950 is available in a Mac specific edition version, and there is the standard PC version, both work in a Mac but only the Mac edition shows a screen during the boot phase. It is possible to 'flash' the firmware on a PC version card to turn it in to a Mac edition card.
The same applies to various other cards in particular the Nvidia GTX-680, GTX-780, and GTX-980. However while an accomplished user can do the GTX-680 themselves the others need to be done by MacVidCards.com
Note: The GTX-680 can still be bought as an official Mac edition card but the 780 and 980 cannot, for those either you stick with the PC versions, or go to MacVidCards.com
As previously mentioned for running multiple cards you will likely need an additional power supply, for example the built-in power supply can only support one Sapphire 7950 or one GTX-680. There are various ways to do this such as using an external PCI chassis which has its own power supply, or fitting an internal auxiliary power supply inside the Mac Pro which goes where the optical drives would normally be, or using an external PC style power supply.
Have a look at this as one example http://forums.macrumors.com/showthread.php?t=1472518
or http://macperformanceguide.com/blog/2011/20110406_1-PowerHungryVideoCards--howto .html