Rocket.Chat allows you to add custom sound files that can be used as a notification sound.
You can customize your notification sound preferences for specific channels by uploading sound files in MP3 format and selecting them in Notification Preferences.