The final phase of Paisley Museum's major transformation is nearing completion after years of planning, investment and community involvement.