It is not only custom sms alter tones for each contact / group, but also custom the ring for each contact / group, easy to use and very cheap, almost is free.
It is the cheapest price and the function is not poor than any other one in the type of softwares.
View it at:
RingSmsToneManager : HTC TyTN II : Handango