Steam has offline mode which does not require internet connection. You still may not be able to play the game if the game itself requires an internet connection, but that has nothing to do with Steam.