The RSPCA and local officials are investigating the "very concerning" situation at the abandoned pond, which has rattled a small English community