Use Custom System and Mail Alerts in Sierra

You can use your own sounds for alerts in macOS Sierra and Mail. You'll need to convert the sounds to AIF format and put them in the Library folder. Then these custom sounds will show up after restarting System Preferences or Mail.