Chief executive of Northern Ireland Water (NIW) Laurence MacKenzie is set to resign over his organisation’s mishandling of the region’s water crisis.