As all eyes focus on the incoming Morrisons chief executive, Jennifer Creevy discovers what the Irishman is made of and asks what his impact on the grocery giant will be