A retired couple have been found dead from suspected carbon monoxide poisoning at a caravan park in the North.