Is it possible to add custom music to the game?

You can customize the music for campaigns without using mods. You can set additional music for battles, for waiting during a turn, and on the map during your turn. The necessary tags are in the campaign.xdb file; you can find an example in the game files.