Mishnah Succot 5:3

ולא היה חצר
בירושלים
שאינה מאירה
מאור בית השואבה

Ve'lo hayah chatzer
Bi'rushalayim
Sh'ayna meirah
May'or bayt ha'sho'evah

There wasn't a single courtyard
in Jerusalem
That wasn't illuminated
By the light of the House of Water Drawing

I "heard" this song during Sukkot 2006/5766 while living at Elat Chayyim (this recording was also sung there).
The text is from the mishnah — read more about Simchat Beit HaShoeva here.
The gemara (Sukkot 51a) further says that whomever did not see the rejoicing at the place of the water-drawing
had never seen rejoicing in their lifetime.