How can I change the notification sound?

A future update will allow you to change the notification sound.

For now you might find it useful to enable the option to flash your screen when you get an alert. Open System Preferences > Accessibility > Audio:

Flash screen

← How can I change the notification sound?