The UK is full of extremely rude-sounding towns and villages. But what’s it like to live in them? Some locals can’t wait to change the names, while others embrace the quirk – even selling signpost souvenirs