No, you cannot go to jail simply for downloading Cheat Engine. It is a legitimate, open-source memory scanning/debugging tool used for software development, testing, and single-player game modification. Possessing it is perfectly legal.
Legal or account trouble arises only when you use Cheat Engine to violate a game's Terms of Service (ToS) or End User License Agreement (EULA):