A charity sleep out at the most northerly point on the British mainland was hit by horrific weather conditions over the weekend in a bid to raise money for homeless military veterans.