The Super Rod cannot be obtained in Pokémon Y.
Reason: Introduced in Generation VI, the Super Rod was made exclusive to Pokémon X. It allows players to catch rare Pokémon in specific areas. Pokémon Y only includes the Good Rod, an earlier version that catches a more limited selection of Pokémon.
To use the Super Rod in Pokémon Y, you would need to trade with a player who has Pokémon X or resort to glitches (which are not recommended due to potential save corruption).