Plans were approved by West Northamptonshire Council despite concerns it could harm the setting of a nearby Grade I listed church