Yorkshire’s mayors have hailed an “historic day” as they sign a new deal pledging to drive growth and improve public transport across the county.