A Link to the Past
The Gargoyle Statue is an object that appears in the Village of Outcasts in A Link to the Past. The Weathercock in Kakariko Village in the Light World is replaced by the Gargoyle Statue in the Dark World and it's also the entrance to the fourth dungeon, Thieves' Town. To open the entrance, Link has to pull the prongs of the trident which the statue is holding on to. It doesn't serve much purpose besides that.
Oracle of Ages
Oracle of Ages (Himekawa)
During Chapter 6, Overthrowing Veran, Veran puts several Gargoyle Statues into life when possessing Nayru. They possess the ability to fly and breathe fire, however, Link defeats them without much struggle.