Plans to demolish a flood-prone house in a Herefordshire village have been withdrawn after going down badly with locals.