Britain's greatest boozer has been officially unveiled after beating fierce competition from across the country.