Eyesore pub disused for 11 years to become shared housing despite almost 200 objections