Water is fundamentally an extremely unbalanced type and needs more than a few changes - both to the type itself and to mechanics that operate with Water typed - to correct it. Granted, the type chart is a really complex machine and it's a miracle that its as well-balanced as it is, but I think Water in particular needs some more checks. As a Seaking (just a Seaking, in fact!) I think I can attest to this with some credibility.
In terms of the type chart, Water is only beaten in “why are you like this” by Fairy and pre-Gen VI Steel. It’s got two weaknesses, one of which is a pretty poor offensive type overall in Grass. Electric actually has a pretty neat interaction here with Rain, but I’m getting ahead of myself. It resists double the types it’s weak to, however - Fire, Ice, Steel, and itself. Resisting yourself is hardly unusual, and neither is resisting a type you hit super-effectively, Something not easily noticed at a glance, though, is that it combines with several types to have absurd defensive synergy - Water/Ground. Water/Flying, and Water/Steel stand out to me in this regard. Its lack of weaknesses comes together really well to form a pretty universally effective. While Steel has many more resistances than Water, this is kept in check by being weak to some very common offensive types - Ground, Fighting, and to a lesser extent Fire. It's also a rather poor offensive type, offsetting a robust defense. That isn't true with Water. Water is also just... a nightmare to deal with in practice, defensively. It has no immunities, yes, but its lack of weaknesses and synergy with common types make it difficult to deal with - and that's not getting into one particular defensive tool that Water types have, Scald, which puts any and all physical attackers opposing a Water type in a really bad position. Either you're a Fire type and Scald will hit you super-effectively, or you just have to run the risk of a 30% burn. Water is far too oppressive as a defensive type when it can leverage burns with no downside, and it needlessly limits your options to deal with a Water type effectively.
Offensively, I think Water is mostly fine - on paper, that is. It hits 3 types super effectively, and 3 types non-effectively. In practice I think it ends up being much more oppressive than that, however - Water types almost universally have access to Ice coverage, which A. somewhat undermines Ice's offensive utility and B. allows them to get around 2 of those types that resist its STAB. (In general I think coverage has gotten far too good across every single type except Electric, but Water has done this as far back as Gen III so I take issue with it in particular). Water has the means to get around two its checks with just two moveslots, and has two more to do whatever it wants with - be that set-up moves, secondary STAB, ally support, or what have you. Rain also contributes to this even further, with nothing except 'mons with Storm Drain being able to keep up with Rain-boosted STAB - much less from 'mons with Swift Swim. Gen VIII even saw fit to give Water types STAB U-Turn, which is thankfully barely kept in check by limited distribution - however, it was still given to many Swift Swimmers, such as Kabutops and Barraskewda, who hardly needed more tools to abuse under Rain. The downside for Rain is evidently supposed to be that you're leaving yourself vulnerable to Thunder, but what good does that do when you're outrunning anything with Thunder to begin with?
So... I've said a lot about what's wrong with Water, but how would I personally change it? This is something much easier said than done given how many moving parts make up the type chart and the game itself, but I'd like to think that the changes I'm about to propose will mostly be a net positive for keeping Water in check while also not ruining the type outright, nor giving any one type too much of an advantage.
1. Water is now weak to Poison - the thematic reasoning essentially being the impact of water pollution, especially by oil. This positions Poison as a sort of anti-meta offensive type, and this + Gen 8's toxic distribution nerf puts Poison in a much better spot than before. I'm neutral on whether or not Poison should resist Water, but I lean on a neutral matchup there.
2. Ice is now immune to Water, and Ice is now neutral against Water. Freeze-Dry exists if you want to hit Water super-effectively, but I think this interaction makes much more sense than before. This also lessens the synergy of Water/Ground and Water/Flying types, and gives Ice the slightest defensive mileage with a wholly unique immunity while also not making it any offensively stronger than it currently is.
3. Highly limit the distribution of both Scald and Ice-type moves. If given the choice I'd remove Scald outright and leave the Water burn gimmick to Volcanion, but if it must stay around I definitely think much more care should be put into who gets it. As for Ice moves, I'm not nearly so keen on suggesting outright removal, especially given how much coverage most 'mons get these days, but I think things should be dialed back somewhat - maybe not every Water type needs Ice moves, nor do they all need to get the strongest consistent option in Ice Beam. You could make a comparison in Fire types getting the perfect coverage move in Solar Beam, but that requires Sun up to get mileage out of it. Ice Beam does not.
4. I think Rain needs a much closer look in terms of balance, to the point that it goes beyond the scope of this post. Suffice to say, however, I think that Rain is an absurdly unbalanced weather condition and just blows its contemporaries out of the water (i'm hilarious i know). It just has so much more in the way of offensive and defensive tools than any other weather form, and while this isn't directly related to Water, I think it very closely interacts with Water to the point where it counts.
With all that said - I don't think Water is actually the best type right now, that goes to Fairy. Being the most unbalanced does not inherently make you the best - just look at Gen 1, where Psychic is the most absurdly unbalanced type ever and yet Normal still wins out as the best by virtue of Gen 1 meta. I just feel that Water is in this odd position where it has almost everything going for it, and has not nearly enough downsides to compensate. I won't act like I'm some all-knowing expert on the type chart or the meta, but I think changing up some things about Water would make it a more balanced type overall. Better yet, we can do this while also lifting up some of the weaker types, which is always a good thing.