It is narrated from Hazrat Abu Musa (may Allah be pleased with him) that the Noble Prophet (peace and blessings be upon him) said: Three types of people will not enter Paradise: a habitual drunkard, one who severs ties of kinship, and one who affirms magic. And whoever dies in the state of being a habitual drunkard, Allah will make him drink the water of "Nahr Ghawta"! Someone asked, "What is meant by Nahr Ghawta?" The Noble Prophet (peace and blessings be upon him) said: It is a river that flows from the private parts of immoral women, and the foul smell of their private parts will cause torment to all the inhabitants of Hell.
Hadith Referenceمسند احمد / تتمہ مُسْنَدِ الْكُوفِيِّينَ / 19569
Hadith Gradingحکم دارالسلام:قوله منه :ثلالثة…ومصدق بالسحر،حسن لغيره، وهذا إسناد ضعيف لضعف أبى جرير