Queensland councils are calling for more state funding to update the state's pipe network, which they say has deteriorated to a high-risk condition.