You can't go fully invisible—your console stays connected to Xbox Live—but Appear Offline hides your presence from most eyes.
To be completely unreachable: Settings → General → Network Settings → Go Offline. This cuts the console from Xbox Live entirely—no messages, no cloud saves, no multiplayer, no Store access.
Use Appear Offline for quiet sessions; Go Offline for total solitude.