It could be your water, but since the only difference you mention is the clear soaps vs the opaque ones.
One thing springs to mind - the clear soaps are glycerin based soaps. Fat based soaps will be opaque. (But not all opaque soaps are fat based, ofc). I do not have any glycerin based soaps so I don't have any experience wit them myself.

Perhaps it's just that your water is better suited for fat based soaps?

Best of luck.