Have you tried registering Python UDF for Databricks SQL? 
These functions are defined and managed as part of Unity Catalog, providing strong and fine-grained management and are available to all users with appropriate permissions. You can call this function as you do for any other built-in SQL function.

Also, you could consider creating a Azure Key Vault-backed secret scope and have MANAGE permission for this secret scope only to the Creator of the secret scope.