My thoughts exactly... swap the pump power supply to the 'permenantly' occupied house as they will use the vast majority of the water. Holiday let will use very little by comparison. Also it'll define ownership of the borehole and subsequent compliance to the Private Water Regulations.