There are many and varied stories about Fiddlers green., some ancient and some strikingly contemporary. Truth be told the word Fiddler in this context probably did not refer to a fiddle but rather to a fid, the spike sailors use for splicing line. Here's my favorite story and song. (thanks again, Wilkepedia)
Fiddler's Green is the happy land imagined by sailors where there is perpetual mirth, a fiddle that never stops playing and dancers who never tire.
History
Fiddler's Green features in an old English legend, to the effect that a sailor can find the paradisiacal village by walking inland with an oar over his shoulder until he finds a place where people ask him what he's carrying. This legend may have some of its origin in Tiresias' prophecy in Homer's Odyssey, in which he tells Odysseus that the only way to appease the sea god Poseidon and find happiness is to take an oar and walk until he finds a land where he is asked what he is carrying, and there make his sacrifice.
It is also the subject of numerous songs, including this about a fisherman who is dying at the dockside
As I walked by the dockside one evening so rare
To view the saltwater and taste the salt air
I spied an old fisherman singing this song
Oh take me away, boys, my time is not long-
"Wrap me up in my oil skin and blanket,
No more 'round the docks I'll be seen,
Just tell me old shipmates,
I'm takin a trip, mates,
and I'll see you some day in Fiddler's Green"
It has been said that only crew, no officers, can go to Fiddler's green!