Sorry to break it to you, but Carbonite already has this feature.
In fact, it's had it for as long as I can remember, and I've been using it for around three years I believe.
Besides the chat notification of a completed quest, in the Options, under Quest Sounds, you can set specific WoW sound files to play when a quest is completed.