If you just want to change the sound of the notifications you receive on your Mac, go to Sound in System Settings and pick your favorite alert noise.