In Pokémon Flora Sky (a FireRed hack), the Super Rod is obtainable via two methods:
Talk to the fisherman on the bridge east of Veridia City entrance. He will give the Super Rod after a brief dialogue.
Purchase for P1,200 from the Market Stall in Olivine City (available after certain story progression).
Note: As a ROM hack, item locations may vary by version (v1.0, v2.0, etc.). Check the specific version's documentation or community wiki (e.g., PokeCommunity, Reddit r/PokemonROMhacks).