Pokémon Shiny Gold is a fan-made ROM hack of Pokémon FireRed (not Gold). It does not add new geographical features like waterfalls beyond the base game's maps.
In vanilla FireRed/LeafGreen, Waterfall (HM07) is obtained on Four Island (Sevii Islands) and used to climb specific waterfalls (e.g., Cerulean Cave entrance, Lost Cave, Mt. Ember).
If Shiny Gold altered HM locations, check the hack's specific documentation (PokeCommunity thread, GitHub, Discord). Most hacks keep HM locations similar to base game.