Welcome to the forums!
Open the Contacts app, select the contact that you want to assign a special tone to, select the Pencil icon to edit the contact, scroll down to 'Message alert' and change it from Default to whatever tone you prefer, then select the Save button.
Sent from my rooted, debloated, deodexed Sinclair ZX-80 running CM -0.001 using Tapatalk