How can I go about adding music to my act and is it worth the effort?

I believe that judicious use of music can elevate and enhance an act if used correctly, but it also has to be said that if not implemented properly it can also ruin or at the very least detract from the act, so caution is advisable. There are a couple of ways that you can consider setting about this. The first is to engage the services of a professional. This might be another magician who already has experience of using music with magic and who can guide you and help to get the music right. The other way is to try and do it yourself. There are several people who have released royalty free music as downloads or on CD (do a web search for these) and when these have been designed with a magic act in mind, they can be very helpful. You still will need to select the right track to set the required mood and edit the track to the correct length, but it is a way forward. But whatever you do, I really would suggest getting the opinion of other(s) because music taste can be a personal thing and it’s easy to get it wrong!