State of emergency declared in Metro Detroit following failure of huge water transmission main