Put it at the very start of an edit to set the theme, then let the main footage take over. Save a Ba Dum Tss Drum Sting for the closing joke, keeping the opening and the payoff clearly separate.