From The Starfield Wiki
Aurora is a psychotropic drug created by the Xenofresh Corporation. Aurora is illegal throughout the Settled Systems, except for the city of Neon. The drug was created after the discovery of a fish with psychotropic properties on the fishing platform that would eventually become Neon. After Xenofresh realized the potential, they repurposed the cities focus from fishing to drug tourism.