Cancer patients being failed by health system, say councillors