How can I animate an opaque material to being fully transparent in Cycles?
You can do something like in the image below. 



Here I have added a simple glass shader to an object and mixed it with a transparent BSDF. Then I simply animate the factor of the mix shader 
(0.0 - 100% Glass / 0% Transparent ; 1.0 - 0% Glass / 100% Transparent).