Are you seeing a family doctor, or a sleep specialist? You want the latter, and a sleep study.
The classes of drugs that might help are imperfect at best, I’d be partial to a benzo before e.g., Ambien or related, given the inherent risks of sleepwalking and worse with those drugs.
Seems like it would be a nightmare to purify. Perhaps useful for agricultural applications, but for drinking and household use…. Most water supplies don’t have e.g., human bodies floating in them.
Not a scientist, happy to be proven wrong here, but that’s my gut.