What is the Drug that depresses central nervous system and causes sleep?

In the literal sense, a narcotic. However, that term has come to be used more broadly to refer to all mood-altering substances without regard to accuracy. Therefore, Central Nervous System (CNS) depressant is used by most professionals, with "soporific" for drugs that tend to produce sleep as a major effect.