If you're looking for music like in the Pubs & Inns movie, head to the library (or the local classical/folk shop if you're feeling rich) and look for Renaissance music, preferably played on period instruments. Most libraries lend CDs. I used to have a few I could recommend, but my ex has 'em all
A few other good sources are (as mentioned) Enya, Loreena McKennit, Gregorian Chant, stuff like that. I have tried symphonic music in the past, but it never really seemed to work. Things like generic Celtic/New Age often work out okay for fantasy settings.
One of the best sessions I ever played with music was in a World of Darkness game with Nine Inch Nails in the background. During a big urban chase/fight scene. Wow.
Oh, you can also try your favourite movie music, but soundtracks seem to me to have the same drawbacks as symphonic: either too dramatic or too flat, and never at the right moment.
Lastly, try listening to some internet radio stations (like with Winamp): filter for the appropriate genres (above), and take notes on what you like, then go seek it in the store (preferably on cheapo collection discs).
Hope that helps,
D
