Controversial plans to demolish the Ebenezer Chapel in West Wylam and replace it with housing have been given the green light.