You will have to experiment with soap : water ratios but hard water will not help your lathermaking at all.
Try a tiny amount of baking soda added to the water or collect rain water or get some distilled water.
Some soaps may lather ok in hard water depending on their surfactant content.