The guppies will be fine in hard water but the others prefer it softer.
Reverse Osmosis (R/O) units are filters that strip out minerals and chemicals from the water and leave almost pure water behind with a pH of 7.0 and 0 GH and 0 KH. You would then mix some r/o water with some tap water to get the GH you want.
Most R/O units simply get attached to a garden tap with a normal hose fitting that goes on a tap. You turn the tap on and water is slowly forced through membranes and filter media and drips out the other end of the unit. You don't normally need to modify anything, just screw the fitting onto a tap and turn the tap on.
You need a container to hold and store the r/o water in. R/O units filter water slowly so you can't turn a tap on and fill up a bucket of r/o water in a few seconds, it takes hours or days depending on the size of the unit.
R/O units waste a bit of water. The good units have a 1:1 conversion rate. This means they provide 1 litre of pure water to 1 litre of waste water. The waste water has all the minerals and chemicals in and is discarded onto the lawn or garden. The pure water is held for use later on. Cheaper units might have a 2:1 ratio or 3:1 ratio. This means they have 2 or 3 litres of waste water for 1 litre of pure water.
If you live in a dry climate and water is expensive, r/o units might not be a cheap option.
The cartridges in the r/o units can last for years, it just depends on how much water gets put through them. They usually say to change cartridges after x amount of water has gone through the system. This can vary a lot and if you have very hard water with lots of chemicals, you might need to replace cartridges more often. If the water isn't that hard and relatively free of chemicals, the cartridges can last longer than recommended. You test the GH of the pure water and change the cartridges when the GH start going back up.