Sleep Overhaul Mod currently adds a Sleepy Head Trait for sims who want to experience an active dream life. Sims will have emotional dreams based on their trait.
(not needed if you have the More buyable Venues Mod it is already included there!!!)Spa Guest NPCs ask autonomously for a Massage at MassageTables & meditate autonomously via MeditationStool