“Enough is enough” says city’s transport convener following second fatality involving a lorry at same junction in less than two years