Already possible with modding, but the practicalities and engineering are somewhat difficult to pull off for a few core reasons when i investigated the possibility of raising fish farms to butcher for bones.
1: Large fish can't be kept in terrariums flipped to aquarium mode because they can't dispel the air-drown effect when they enter the cage despite it being the appropriate "holding" for them, amphibious creatures can be transferred over fine to live with your fish in the aquarium however without any risk of drowning.
2: Pitting is clunky, and while a wild fish can live in a dry cage trap on being captured, once they're trained they have to live in their pitted pool virtually forever moved by water flow or quickly dragged overland.
3: Pathing underwater doesnt work as efficiently as overland, as obviously nobody besides ghostly animal-trainers can even pull animals underwater to the right place and can't be motivated to move them with pastures or meeting areas because of a lack of valid floor.
At best you can chain sharks then speed-flood a pool to be guard-dogs, but this is often unreliable, but sharks have the advantage of being able to live birth so tamed sharks should in time contact breed some free-swimming pet sharks on patrol. Restraints to my memory also wont hold back a creature from being washed away if the pressure is moving horizontally rather than draining down.
Itt: Modded amphibious mudsharks with absolutely terrible land-speeds might be the answer.