Canadian Pacific Railway, the second-largest railroad in Canada, is exploring a takeover of U.S. carrier Norfolk Southern Corp. in a fresh attempt to consolidate the North American industry, according to people familiar with the matter.