Anveo - The Smart Way To Use Your Phones does what you want and then some.
I use it and it only costs a few bucks a month at most.
Real number in any area code you want, can receive texts, and even forward them as well to your non-USA number.
*Extremely* robust admin interface.