The $4.99 Word Lens iPhone app from QuestVisual uses optical character recognition to identify words in an image and translate them, and then draw them back on the screen.

It currently offers only English to Spanish and Spanish to English translation. Other languages are planned.

You can try it out for yourself here.