'Council tax money is going on something that should be supported by the Welsh Government,' said one councillor