Sheffield retains ‘real ale capital of the world’ title, as thriving brewing industry drives tourism and regeneration