The latest plan to convert an eyesore former pub - described as “a detracting feature in the area” -into housing has been approved.