A former church described as "the hub of the community" is set to be knocked down and replaced with a shop