Are there any night tours?

Literal

Night [gen-の] tour [topic-は] exists-[polite Q-ますか].

Basic polite yes/no question. ツアー is an English loanword. The frame [noun]はありますか ('is there X?') is a workhorse for tourist counter exchanges — the same template covers asking after discounts, packages, or any service item.