The good rod is found on route 118 by the fisherman by the shore. The super rod is found in mossdeep city, in the house north of the space centre.