Hairy Black Holes from Horndeski Theory