Maybe this is old news, but I figured out how to do this in Messages last weekend.
On any conversation in messages, go to the 3 dots. There is a Notifications setting. In there you can set it to "custom" and choose any sound in your phone.
Hope this helps.....