City united in grief after passing of Queen and end of 'momentous reign'