What tools do I need to change 92 Camry water pump?

Depends on your vehicle model, but probably a set of wrenches and/or a socket set will suffice.

They're frequently located in difficult to reach areas, so you might want those to be long-handled offset wrenches. In some cases, you can come in through the wheel well, so whatever it takes to remove the mud guards from there could be useful also.