Scottish island set for new water treatment plant