You will unlock songs as you progress through the story and by doing quests. Once you have obtained the song all you need to do is drag the song from the Sheet Music tab to your action bar and click it to play it. Once the channel time is finished (aka once you've played the song), the effect will activate.