Luke Gale's extra-time drop goal saw Leeds complete a thrilling comeback to defeat Huddersfield 27-26 in Super League.