Southern Water is to give £9.7 million in compensation after 58,000 households in Hampshire went without supplies for nearly two days.