I've searched the internet for references to John of Dreams in the hope of finding a folklore character but I've come up relatively empty handed.

I've found:

1) The song. (It was the song that prompted me to look in the first place.)

2) A speach from Hamlet that refers to John-A-Dreams.

I'd love to learn more.