Good Rod: Obtained from a fisherman on a jetty on Route 209.
Old Rod: Obtained from a fisherman in Jubilife City.
Super Rod: After defeating the Elite Four, go to Snow Point City. Your rival will invite you. Take the boat to the fight area. As soon as you arrive, go up and there will be a fisherman. He will ask you a question, agree with him and he will give you the Super Rod.