Will I still be able to have sex after a vasectomy?

Yes. A vasectomy will not alter your sex drive. Your erections and orgasms will be the same. You will have the same amount of ejaculate (semen), but it will not contain sperm.