Council's ageing drain network needs million-dollar fix