Anti-androgens and GnRH agonists like Spironolactone, Cyproterone Acetate, Goserelin Acetate, Bicalutamide to name a few. Also to a lesser extent 5α-reductase inhibitors like finasteride (Propecia) which only suppress the more potent dihydrotestosterone.
All of these work by suppressing androgen production (mostly testosterone and dihydrotestosterone), this will suppress most of the male libido. While they don't remove the ability to get an erection if you try, they will prevent the hormonal lead-up that would normally lead to one. You'll likely stop thinking about sex entirely, there won't be much of a drive. GnRH agonists like Goserelin Acetate (zolodex) are highly effective, spironolactone is very weak and a potent diuretic.
On the downside... an adult human body expects to have a dominant sex hormone, either testosterone or oestrogen, and a lot of things hang off this. For one, initial breast growth is inhibited by testosterone, so you will likely develop gynecomastia (unwanted breast development). Your body hair will reduce, though facial hair is mostly unaffected, and your skin will become softer. Long term you are at increased risk of developing osteoporosis, and your testes and genitals will shrink. Sperm count and viability will reduce, though for some people this is recoverable.
It will halt any male pattern baldness though.
Most of these drugs are used for treatment of prostate and testicular cancer, so their effects are well known.