You can do two thing
1) under the section of the unit editor that is for configuring attacks, you can set an attack sound. Unfortunately, this can't seem to use very many of them.
2) Some missiles have a sound included in them, by using them for the missile art you'll get a sound.