Nearly all of Manchester Piccadilly train station is set to close for nine days next month as part of a "major overhaul" to improve future journeys for passengers as well as freight.