The road to Heaven is narrow, and walking across that narrow road while drunk on alcohol or under the influence of other drugs may result in you falling off that narrow road into Hell.
If you used to drink alcohol, smoke or chew tobacco, or use illegal drugs or abuse prescription drugs, Jesus Christ will forgive you for doing so and help you quit, as long as you ask for his forgiveness while still on Earth.
Last but not least, I firmly believe that when Jesus turned water into wine, that wine did not have a single molecule of alcohol in it. Any wine in Heaven will be the same way, so you could drink an entire ocean of it and not get drunk or tipsy as a result. Don't try to make the wine Jesus made yourself. You will fail.