Target names longtime executive Michael Fiddelke as CEO as the retailer plans major store upgrades and a digital revamp to revive sales.