Sunan an-Nasa'i, Book 51, Hadith 137 (In-Book)

It was narrated that Ad-Dahhak said: "Whoever dies addicted to Khamr will have boiling water thrown in his face when he departs this world."

أَخْبَرَنَا سُوَيْدٌ، قَالَ أَنْبَأَنَا عَبْدُ اللَّهِ، عَنِ الْحَسَنِ بْنِ يَحْيَى، عَنِ الضَّحَّاكِ، قَالَ مَنْ مَاتَ مُدْمِنًا لِلْخَمْرِ نُضِحَ فِي وَجْهِهِ بِالْحَمِيمِ حِينَ يُفَارِقُ الدُّنْيَا ‏.‏

sunnah.com