Built in 1939, a 9.15-inch cast-iron water main in the Bourne Water District of Cape Cod, Mass., runs above ground as it crosses a railroad bridge, then continues underground again.

The line operates at 95 psi, and no one knew if the old valves worked. A rupture anywhere along the...