One of my all-time favourite theme tunes has to be the theme from "Only Fools and Horses". That and "Hookey Street" from the end credits.
Another couple of tunes that deserve honourable mention are the Friends theme, "I'll Be There For You" and the Cheers theme, "Where Everybody Knows Your Name".