Of course "Goodnight Moon" is a lovely goodnight story, and the lullaby that I wrote for our Beamish Boy and am re-using for Big Will figures the moon prominently ;>

Also, an oldie but a goodie (in a weird, will pop up in your dreams ear-worm kind of way):

http://www.rathergood.com/moon_song