Formal:
* Bonne nuit, Mesdames et Messieurs. Faites de beaux rêves ou de beaux cauchemars.
This is the most direct translation and is appropriate for formal settings.
Informal:
* Bonsoir tout le monde. Faites de beaux rêves ou de beaux cauchemars.
This is more informal and could be used with friends or family.
Note: In French, it's common to wish someone good night with just "bonne nuit" or "bonsoir." You can add "Faites de beaux rêves" if you want to specifically wish them sweet dreams.