Cydia app store is now offering a new app that will allow you to view the picture of the person who has sent you the SMS message. The pictures are taken from the contact to which an image is already added.
Named ChatPic, the jailbreak app puts a picture of your contact beside each incoming chat bubble. However, the ChatPic app is not compatible with third party texting apps like BiteSMS and iRealSMS.
ChatPic is available for dollar one via BigBoss repo.