What is the failure rate on a vasectomy?

Very nearly zero.

If you want to be made permanently sterile, a vasectomy is the way to go.