Non-ergodic phenomena in many-body quantum systems