It'll be the mechanical seal in the water pump that's failed if it's leaking through the drain hole, which is exactly as you say a tell-tale to let you know there's trouble and to prevent cross-contamination of oil and water from the two sides of the pump.
Have a read of
this thread. It covers parts needed and the basic outline of what you need to do.