Councillors in Aberdeen have thrown out multi-million pound plans to transform the centre of the city.