Plans to turn former chapel into ‘vibrant community space’ given go-ahead