K.T.
The first thing that came to mind was Lee Ann Womack's "I Hope You Dance" and I see that others thought of that as well. Great song, and very touching.
Another song I have always loved is "Somewhere Out There" from the kid's movie American Tale, or "I Don't Want To Miss a Thing" by Aerosmith, and also "Isn't She Lovely" by Stevie Wonder