Every time cities propose a million- or even billion-dollar infrastructure upgrade, there’s one small seed of doubt at the back of people’s minds: Will it really be worth the cost?

Houghton, Michigan, no longer has to ask that question, thanks to some new pipes that proved...