The Android version of Facebook lets you select a different tone for in-app notifications. Select the More menu (three lines) > Settings & Privacy > Settings > Notifications > Push (under Where you receive notifications) > Tone, and then select the alert sound you want.