The story
From the stereotype of the Irish as stupid, and the fact that smoke rises, unlike a proper waterfall.
Etymology from Wiktionary, CC BY-SA 4.0.
Irish waterfall
Today it means: French inhale; inhaling smoke that has just been expelled from the mouth or inhaling smoke through the nose while simultaneously expelling it from the mouth. Full definition →