Gary Hooper's late goal secured a 1-0 SPL win for Celtic as Motherwell paid the price for missing a penalty at Parkhead.