Change the notification sound

In Settings, go to Notifications, then Sound, and pick one. It plays for new messages both inside the app and on the lock screen.

You can give one chat its own sound too: open the chat, tap the name at the top, then Sounds & Notifications.