North River Co. plans to transform the former Lockwood Mill at 6 Water St. into 65 affordable apartments and some commercial space as part of the $40 million project.