I did my CPS last spring. Not the worst job, but not the easiest either. It does involve removal of the timing belt from the cam gear and removing the cam gear from the cam. You have to be very careful not to mess up the timing.
How many miles does the car have? Have you changed the timing belt yet? If not, I would get the timing belt, metal water pump, tensioner and the CPS done all at the same time. How handy are you? Have you done anything like this? Do you have a friend to help you? What sort of tools do you have or have access to? This is not like changing a water temp sensor or brakes. It requires specialized tools, or a very good understanding of what you can substitute.
That being said, I used the following tools;
1/2" breaker bar
1/2" ratchet and sockets
Cam gear holder tool thingy
Open end/box end combo wrenches
Followed by the intoxicant of your choice.