No there are not plenty. Sure 70% of the earth is covered in water, but only 2.5% is freshwater, and a fair amount of that is lakes large enough to have currents and large waves as well (I don't know how to figure out how much is stable enough that you could consider living on a boat there. I think we can estimate that 2% of the earth is the type of place where you could consider living in a boat - and much of that isn't a place where you want to live (ie not a city), and the rest needs to a lot of land reserved for shipping lanes.
Living in a boat is an interesting niche that a few people can do. However it isn't a solution for any housing problem.
That's true in Amsterdam, and it's true in San Francisco. And it's true in Berlin where I currently live. Plenty of space to build cheap apartments on but it's controversial in all three to do so. So, this is a nice solution/workaround for this artificial scarcity. I imagine the Bay would be suitable for living on. But of course most of it is protected nature. That's a much more valid concern than the notion that there's not enough water.
I actually looked into what it would take to put a housing boat in the Spree (river that runs through Berlin). People actually do that and you can get some decent value for money! Obviously it won't scale before local authorities put a stop to that (to preserve the local artificially scarcity and locked up wealth). But it's an interesting loophole if you are a bit entrepreneurial. No expensive land needed to build on. Easy access to reasonably fashionable parts of town. Etc. All you need is a boat and permission to dock it somewhere. As long as that permission is still easy to get, it's a valid thing to pursue.
https://ourworldindata.org/land-use
It seems that human development and freshwater are the same.
You are floating in water. All you need to do to use it is filter it. For waste water, you need to clean it up before you release it back to where it came from. Most of the tap water in Amsterdam comes from the water that surrounds it in any case. For energy, solar, wind, and batteries should go a long way. The main thing you need is enough square meters for the panels. 50KW should go a long way even on very cloudy winter days. If you insulate the houses/boats properly (i.e. lower your energy needs) it barely needs any heating or cooling. Also, you are floating in water, which makes heat exchange pumps really easy (no need to dig in the ground). Lots of nice engineering problems to solve there. Phone/internet can be wireless these days 4G/5G, or space link. There is no need for gas if you heat & cook electric. This looks like it still uses some shared infrastructure (probably for cost/efficiency reasons) but you could feasibly design something that is completely self sufficient. The key thing is to make durable structures that don't need a lot of maintenance, that are energy efficient, etc.
As for the other risks. Boats sink occasionally but rarely when they are safely docked in a harbor. You obviously don't want to dock in a place that has currents, large waves, etc. There are plenty of secluded lakes, channels, etc. that should be perfectly fine for this.