The Mac Pro provides power to video cards via the PCIe slot itself and one or two 6-pin PCIe auxiliary power leads. The PCIe slot itself provides 75W, each 6-pin cable officially provides 75w making a maximum total possible of 210W.
As there are only two sockets on the Mac Pro logic board for auxiliary power this means you can either use one video card with 75+75+75 or two video cards with 75+75 and 75+75. Since the video card you want to use requires two 6-pin auxiliary power leads as well as the PCIe slot power officially you would not be able to have a second video card. Therefore the answer is yes if you want to use the GTX 980ti and a second video card you should use an additional external power supply.
For what its worth an 8-pin auxiliary PCIe power connection would provide 150W but the Mac Pro does not have such connections. Some people have successfully drawn more than the official 75W per 6-pin connection on the Mac Pro logic board by using a 6-pin to 8-pin adapter but the danger is that over time this may burn out the logic board.
PS. Some people fit a second additional power supply internally into the optical drive bay of the Mac Pro but still having the power lead run outside the Mac Pro via an empty PCIe slot.