WordLens works offline without any additional downloads, at least for the languages I tried (Spanish, French, English).
Audio translation and TTS works offline if you have the proper languages downloaded, but being able to detect what language is being spoken seems to be an online-only feature.