The cannons are actually part of the original score. Here it is with them, and here is a performance without them. I have linked to the part used in the Mythbusters clip (which includes the brief prelude to the famous ending).