Sodium actually poisons a plant so water softeners are bad bad for plants. Hard water, ie water high in calcium and magnesium, has different issues. While these minerals are indeed needed by the plant, in excess they can burn/inhibit root growth.
What happens when you water a plant with 200ppm water and then half the water is transpired/evaporated from the potting mix? Is the remaining water 200ppm? You bet it's not! The water around the roots is now 400ppm! What happens to the root hairs and fragile cells on the roots growing tips when they hit water with a high osmotic potential like that? They get the H2O sucked right out of them and burn (die).
Can you use tap water? Maybe... depends on your tapwater. Quality can vary vastly. Some plants can handle higher mineral concentrations better. Nepenthes for one. Other factors can play a roll too. Are the plants overhead watered and allowed to drain freely on an almost daily basis? Do they sit in trays where minerals will continue to collect? Do you repot frequently to remove mix that has become loaded with minerals? Don't forget that even high quality water 25ppm or less will eventually cause a problem if a plant is on the tray method, rarely flushed from above and repotted very infrequently. Naturally the better the water the less likely and less frequently problems with minerals will occur. So everyone needs to be aware of the POTENTIAL danger when watering and the long term care of their plants and how they are all interrelated with type of watering method, potting mix composition, frequency of watering, any use of fertilizers etc.
Tony