Pipes can last centuries or only years, depending on the material, the temperature, and the solutes in the water — even without getting into cases where the pipes actually break. Both lead and copper (which is more common than brass!) can last centuries in cold water that isn't chemically aggressive. Heck, in Boston a few years back, they dug up some wood pipes that were installed in the 1700s.