I'd use custom items to accomplish this. First is an item to allow your aquatic animal to walk:
Belt of Piscine Endowment
Aura faint transmutation; CL 5th
Slot belt; Price 30,000 gp; Weight 1 lb.
DESCRIPTION
When above water, this belt seems to be made of sharkskin. When below water, it seems to be made of the skin of a furry mammal.
When worn, this item allows aquatic creatures to grow legs and gain a land speed, exactly as the spell fins to feet.
CONSTRUCTION REQUIREMENTS
Craft Wondrous Item, fins to feet; Cost 15,000 gp.
Since all aquatic creatures either have a belt slot or a land speed (at least, all the ones I know of do), this works on all non-walking aquatic creatures. Before you can afford this item, you can use the Fins to Feet spell, which is a level 3 wizard, witch, and druid spell.
For the ability to breathe, there are a few options, depending on how much you want to stick to RAW.
First is a custom magic item of sea steed (18,000 GP). This is intended to allow land-based animal companions to work as sea-based animal companions, but it works just fine either way. This gives the animal the amphibious quality, allowing it to breathe on land as well as under water. This spell doesn't last long enough to make it practical as something to cast regularly before you gain access to the item.
Second is the Waterskin of Woe (80000 gp). This item lets you remove all the water from a creature, and "does not need to breathe, eat, drink or sleep and is immune to non-lethal damage." Since it doesn't specify what you no longer need to breathe, it should work on your shark just fine. The problem with it is that it deals 1 point on Constitution damage per day that it was used once you stop using it, and can only be used for a number of days equal to your Con score. However, there is no limit to the number of times you can use it per day, so you could easily turn it off at night, heal any Con damage with lesser restoration, and turn it back on while the aquatic creature holds its breath.
Third is the Necklace of Adaptation (9000 gp). There are a few problems with this as written. For one, it is a neck slot item, and the magic item slots for animals guidelines say that neither sharks nor octopi have neck slots. However, you might be able to make the argument that you could put it on a belt slot instead, possibly for a higher cost. Next, it specifically talks about creating a "shell of fresh air" around the user, which doesn't really help aquatic creatures. Again, I think the argument could be reasonably made to allow a shell of fresh (or salt, I guess) water to be used instead, if the item is made for aquatic creatures.
Fourth is a custom magic item of life bubble (56,000 gp). This effectively works like water wreathing, but it doesn't specify that it lets a creature breathe air, only that it lets a creature breathe comfortably. It actually creates a 1 inch shell of "tolerable living conditions", which could be fresh or salt water as easily as air. For a shark, it's probably moving water, which will likely be a tad inconvenient.
Since fins to feet is 3rd level, and life bubble is 4th level, you can have a land-based shark or octopus by 7th level for the cost of 4 spells per day. 2 castings of fins to feet will get you through an adventuring day, and 2 castings of life bubble will get you through the 24 hours that you need to keep your animal breathing. Since most aquatic creature have limited equipment slots, you will likely need to put two of these effects on the same item, likely a belt. This will cost the same as the added cost of the two effects, plus half the cost of the cheaper ability (or the new ability, if created in play).
IF you want to go the super-expensive route, you could also gate in a Personification of Fury every morning, since it has a special air breathing spell-like ability, which works like water breathing, but lets aquatic creatures breathe air.
Willingly, yes. Unwillingly, probably.
The Ring of Water Walking has the following rules text:
While wearing this ring, you can stand on and move across any liquid surface as if it were solid ground.
Being willingly pulled under or diving
First I note the word can which makes it clear that the wearer has to choose to use this effect. Since there is no defined timing restriction on when they can make that choice I will assume they can do so at any time. I also note that this effect only applies to a liquid's surface, but doesn't explicitly do anything when you are submerged.
Thus you can always end the effect of the ring and let yourself be pulled underwater or simply dive.
Being unwillingly pulled under
This ring allows us to treat the surface of water as though it were solid ground, but just like solid ground it is by nature an uneven surface under which creatures dwell.
If a burrowing creature could reasonably grapple a target and pull it underground using its burrow speed, I see no reason why a swimming creature couldn't grapple a target and pull it underwater using its swimming speed. Just like being pulled underground you're not on a solid surface anymore as it is being parted to pull you in.
As soon as you start sinking the Ring of Water Walking will no longer be of any use to you given that you are not on the water's surface anymore.
Just like being pulled underground you could try to brace yourself onto the surface with your arms but allowing for this is squarely in DM territory.
Best Answer
In D&D 5e, a Giant Octopus (MM pg 326) is a large creature taking a space of 10 feet by 10 feet (MM pg 6) or a 2 by 2 square. In both the DMG and PHB (DMG pg 116-117 PHB pg 182/198) nothing is said about how much water is needed to allow something to use its swimming speed.
My personal ruling, in the case of a Giant octopus, I would require at least a 5 ft depth (half the height of its space) to allow it use its swimming speed, but let the player know that any aquatic form they transform into may need a greater depth than half the height of its space in order to perform certain actions (Like a Great Reef Shark jumping out of a river to bite someone on a bridge vs Great Reef Shark jumping out of an ocean to bite someone on a canoe.)