The skooma can be traded with Borkul the Beast to have Madanach's cell unlocked. One bottle is on a table next to a flute. About five bottles of Skooma in the shelf, as well as other provisions, ingredients, and a locked chest. If you respond to the NPC by asking if it is illegal to sell skooma, he will attack you and you will be able to loot his skooma and other items (including Sleeping Tree Sap) once he is defeated. You can, however, obtain it at the following locations:
No, you can acquire all of its ingredients but cannot reproduce it.