Designing resilient and economically viable water distribution systems