Former Castle Point Council leader Andrew Sheldon has been cleared of wrongdoing over his investigation into over £1m of missing taxpayers' money.