Chords used:
     G: 320003
     Cadd9:  x30010
     Em7: 020000
     D:  xx0232

Strumming pattern: DUUDUDU
Capo 2
If you don't have a capo, you can raise the song 1 full step, making the chords A 
(x01230), Dadd9 (977778), F#m7 (102340), and E (023100).
You could also simplify it by using D (xx0232) and a simplified version of F#m (xxx222).
If you use D and the simplified F#m, it won't sound as good, but it will still sound decent.

Intro: G (DUUDUDUDUUDUDU) Cadd9 (DUUDUDUDUUDUDU) G (DUUDUDUDUUDUDU) Cadd9 (DUUDUDUDUUDUDU)

G
Dragon tales and "The water is wide"
Cadd9
Pirates sail and lost boys fly
Em7                D
Fish bite moonbeams every night
     Cadd9
And I love you

Cadd9
Godpeed, little man
     G
Sweet dreams, little man
       Cadd9
Oh my love will fly to you each night
   Em7 D    Cadd9
On an-gels wings

Godspeed
    G
Sweet dreams

G
The rocket racer's all tuckered out
Cadd9
Superman's in pajama's on the couch
Em7                   D
Goodnight moon we'll find the mouse
   Cadd9
and I love you

Cadd9
Godpeed, little man
     G
Sweet dreams, little man
       Cadd9
Oh my love will fly to you each night
   Em7 D    Cadd9
On an-gels wings

Godspeed
    G
Sweet dreams


G
God bless mommy and match box cars
Cadd9
God bless dad and thanks for the stars
Em7                   D
God hears "Amen" wherever we are
  Cadd9 (once)
And I love you

Cadd9
Godpeed, little man
     G
Sweet dreams, little man
       Cadd9
Oh my love will fly to you each night
   Em7 D    Cadd9
On an-gels wings

Godspeed
Em7
Godspeed
Cadd9
Godspeed
      G
Sweet Dreams

Cadd9  (DUUDUDUDUUDUDU) G (DUUDUDUDUUDUDU) Cadd9  
(DUUDUDUDUUDUDU) G (D)