Use the free GarageBand app on your iPhone to turn your sound file into a ringtone.
Common text message sounds for videos or apps. Screenshot Sound: Specific camera capture sounds. Iphone Sound Free
Once converted, go to Settings > Sounds & Haptics > Text Tone to assign the new sound to messages. Use the free GarageBand app on your iPhone