It can be hard to escape the rain on holiday in the UK, but one spot has been named as your best bet.