The Floria Waterfall is found outside the Water Dragon Faron's hall near Lake Floria. It is first visited by Link as a shortcut to Faron Woods after Faron asks him to retrieve some Sacred Water from the Skyview Spring to heal the wounds she received from Ghirahim in an earlier battle. After Link collects the Sacred Water and heals her wounds, Faron leads him outside to Floria Waterfall to reveal the location of Farore's Sacred Flame. Faron uses her power to halt the flow of the waterfall, clearing a path to the Ancient Cistern, which holds Farore's Flame.
↑"Go. The sacred flame you seek lies within this place. While the waterfall has barred entrance to this place for many years, monsters have still found a way in...and inside they flourish." — Faron (Skyward Sword)