Yes, that's a cartridge bearing bottom bracket that will work with a crankset that's designed for use with a JIS square taper bottom bracket (very common). As already discussed, it threads into the bottom bracket shell, with the right side being reverse threaded. But it is not suitable for underwater use (as noted, no bicycle bottom bracket is suitable for that). You'll need to figure out a way to keep the assembly relatively dry-