Hi, ServiceNow does offer a self-hosted\on premise solution
self-hosted-software-support-guidelines.pdf (servicenow.com)
I am not aware of any difference in password management process or storage between on-premise and cloud SNC solutions, but this (and any other questions relating to on-prem solution) would be best raised with your SNC account manager.
