Welcome to the forums!
I use Go SMS (free from the market) - an option in the messaging app is to move messages to the private inbox. The private inbox is password protected, so it offers a little more protection.
I have also heard of, but never used, an SMS app like Shady SMS (not sure if this is free or paid for) - as I haven't used it, I can't say how good/bad it is!