The city council's leader said the scale of visitor numbers had been "significant" and learnings would be taken from the day