The happiest song I know is Never Too Late by Hedley. Dunno about the words, though. I don't usually pay attention to them.
Sweet Child o Mine, I find, is another song that always makes puts a smile on my face!
I know a couple of you mentioned Don't Worry, Be Happy, but I actually find that...