Where is the water pump located on a Mazda mx5?

You say MX5, not Miata, so do you really mean 2006 or newer MX5? If you really mean 1990-2005 Miata then the water pump is behind the timing belt cover. It is not driven by the t-belt, but the t-belt must be removed to change the pump.