An estimated 935,000 people in the Greater Detroit area were put under a boil water advisory on Saturday after a leak was discovered in a 120-inch water transmission main that distributes water from Lake Huron Water Treatment Facility to residents, the Great Lakes Water Authority said.