Within the game itself, the lights do not wake up or keep up any peep in the house.

Your family members will normally only sleep for one sleep-cycle at a time. Each cycle is about 5-10 mins long. Depending on how low their Energy bar is when they wake up, the child (or adult peep) may still be tired and either go take a nap, go back to bed, or do something relaxing. If they are well enough rested (or wide awake) you won't be able to put them back to bed.

For more information on sleep habits, please check out these helpful threads: won't sleep, how much time does it take for a family to get well rested?, Can't make them stay asleep, and of course in extreme cases, Tired/Exhausted.