Very generally speaking fish are pretty adaptable. But fish that originate from soft acidic waters, especially if they are wild caught [ a LOT of them are wild caught] and not from a fish farm, may not do so well in very hard or alkaline water.
I've come to believe that it is best to either accept that your water is what it is and get fish that are most likely to do well in it, or accept that your water needs changing to keep the fish you want to keep, in which case, installing an RO filter, or buying RO water from a store, is the most sensible solution.
RO water needs to have something added to it to bring the mineral balance in line with the fish being kept.. as it has NO minerals in it at all when it's fresh from the filtration system.
This is not hard to do, but it is an added expense. If you want to breed the fish, having water that suits their needs is even more important.
It is certainly possible to cut tap water with either RO or DI[ distilled] water to reduce the hardness and pH, but how much of the filtered or DI water you need may tell you whether you want to go with an installed RO fllter, or lug bottles home from the store.
Live bearing fish, such as guppies or platies or swords, are suited to the type of water you have now. They aren't the only ones, but are among the most popular. Mollies are also very suited but are not a good fish for beginners, being more sensitive than some others to mistakes in water conditions.
Kudos to you for checking into this kind of thing though.. it's the best way to go on. The more you learn, the more success you will have in the long run.