Yes, a water pump can leak even when the engine is off. The water pump is part of the cooling system, and if it's faulty, the coolant can leak out regardless of whether the engine is running or not. This is particularly noticeable when the car has been parked for a while, and a pool of coolant is found underneath.