A body has been found at Whinny Gill reservoir, in Skipton in the search for a missing Britain's Got Talent semi-finalist from Yorkshire.