The CEO of Southern Water has issued an apology after thousands of people across the county were left without water.