LoRa sounds like a good idea for water sensing in particular. Water catches all radio signals at 2.4 GHz and turns the waves into heat (that's why microwave ovens work, after all), so spread-spectrum transmission seems like a good way around that issue. I would test the transmission range in a bathtub.