10/10/2012 at 09:30 AM EDT
may have pleased fans by – finally! – returning with a new single
, the James Bond theme "Skyfall," but the singer has something bigger to be excited about: motherhood
"She is just thrilled," an Adele source tells PEOPLE in its latest cover story, about the Grammy-winner
's private world and how she is prepping for her first child.
As the 24-year-old pop star awaits the birth of her baby with boyfriend Simon Konecki
, 38, she is happily remaining out of the spotlight.
"She is totally laying low and nesting," says the source.
Insiders also reveal the secrets of how her chart-topping single came about – and what a joy it was to work with the mum-to-be.
"She spent a lot of time working on it and getting it right," Skyfall
producer Barbara Broccoli tells PEOPLE, adding that Adele even read the movie's script. "But she was worth the wait."