Surf is better in-game and competitively IMO, as if you use Hydro Cannon you get to attack once every 2 turns essentially. With Surf, you can attack every turn, resulting in more damage done to the enemy.
Also, it should be noted that another option is Hydro Pump, just if you want that extra bit of power to help KO enemies.
Hope I helped! :)