Feat: Secret providers should support writing secrets to secret manager as well

[ffforest]

What would you like to be added?

Add the ability to set a secret in the secret manager via secret provider

Why is this needed?

Currently the secret provider will only be able to retrieve a pre-existing secret that is stored in the secret manager out-of-band by the user.
This feature will allow user to store the secret in the secret manager via Kusion secret provider.
This feature will be further utilized by variable apis in the future when a variable is marked as sensitive variable.