An Ohio cop resigned after he was caught posting “highly inappropriate” content on social media that suggested he would shoot people