Bolstering Sir Sadiq Khan and other mayors’ powers marks the “biggest transfer of power out of Whitehall” in decades, a minister has said.