There are plenty of reasons to visit the charming UK village but most tourists admit they're there purely because of the destination's memorable name