All you need to do is tell your pdoc you would like a sleep medication but don't want Ambien because of the sleep walking. Your pdoc will suggest some options. Hopefully he will not suggest klonopin for sleep.

Here are some ideas:
Non prescription: Melatonin, Valerian, Magnesium
Presciption: Vistaril, Remeron, Trazodone, Seroquel, Temazepam

For shutting off your mind prior to sleep (persistent and/or racing thoughts), an SSRI might help..