Serebii fortunately has a list of Pokémon with swimming animations, so we can simply figure out which of these Pokémon that aren't Water type can be found in water.
https://www.serebii.net/scarletviolet/swim.shtml
Of these Pokémon, the Pikachu line, Galarian Slowpoke line, Eevee line, Paldean Wooper line, Hisuian Qwilfish line, Azurill, Tynamo line, Skrelp line, Bergmite line, Eiscue, and the Pawmi line all have swimming animations. Gholdengo and Lugia also do, but I believe them and their pre-evolutions can only be found in static encounters.
Despite this, Bulbapedia states that Pokémon that normally walk on land but fly over water (such as Tropius) also receive the Dive Ball buff. Would you also like to know these Pokémon?