The name "smelly sister" may be an intimate or teasing title, which is usually used between close members of the opposite sex. This title may have some humor or banter, but it is not necessarily malicious.
The specific meaning of this title may vary from person to person or from situation to situation. In some cases, this may just be a relaxed and informal name; In other cases, there may be some teasing or banter.