It does depend where you are. However, some tap can have things like copper which can harm some fish, like angels. It also harms inverts. As you mentioned you can have algae problems, Higher nitrates and phosphates which can also harm fish.
Many say that tap water issues don't show up for a year+ down the road.
Not recommended, but yes there are people who use it for fowlr