Councillor Brian Tierney has apologised to fellow elected members for the “huge, huge mistake” of providing a reference for a former soldier who was later convicted of rape.