There is no drug that will make someone want to have sex with you, and if there were using that drug would be rape. If someone doesn’t want to have sex with you and you give them a substance to change their mind, you are attempting rape by trying to override their consent.
There are drugs that impair people’s decision making ability.
There are drugs that impair co-ordination and motor function.
There are drugs that interfere with memory.
Using any of these drugs to render someone vulnerable so that you can take advantage of them sexually is rape.