Police are hunting an attempted burglary suspect who was last seen on the garage roof of a property in North Yorkshire.