Who is that leaning on the gate?

Literal

Gate [on-に] is-leaning-[ている] person [topic-は] who [copula-ですか].

もたれる ('lean on, rest against') takes its support with に. The ~ている form describes the resulting state. Standard 誰 question with copula.