A Hampshire pub has been named one of the ‘friendliest’ in the UK following a research study.