Canadian Pacific Railway Ltd. agreed to acquire Kansas City Southern in a transaction valued at about $25 billion that would create the first freight-rail network linking Mexico, the U.S. and Canada.