Mate, a popular spot remains the Cod hole, which is an area around the Maroochy Motorway bridge.
Ask any local where Swan's boat hire is. That is basically the Cod hole. There is some really good fishing around that area, especially at night.
Enjoy your holiday here!