Presumably "Moon and Sixpence" is something to do with the full moon looking like a sixpence held at about arm's length. You know: they're both round and silver and, um... well that's it really.

Somewhere (Grantham?) I've see a Dew Drop Inn.

In Long Eaton (and no doubt other places near canals) there is the mildly amusingly named Barge Inn.

In Grantham there is a "Muddle Go Nowhere" which sounds like it might be a local expression, although I don't know.

I dislike it when a traditional nick name is officially adopted by the pub. Contracting a name - "Queen Victoria" becomes "The Queen Vic" or "Vicky's" - is even worse.