To use Google Translate while offline, you'll need to download the language dictionaries you want onto your phone.
Siri can translate words and phrases into about a dozen languages and host a conversation in two different languages using the Translate app.