Is there a train from Harrogate to Heathrow Airport?

No, not directly, you would need to take the train to York and then take the King's Cross train into London, from King's Cross/St Pancras you can then take the Piccadilly Line tube to Heathrow.