Thames Water chief executive Chris Weston has apologised to customers and promised to turn the failing utility company around.