Lib Dem councillors left frustrated at other parties' lack of support for canals motion