A former senior CIA official with top secret-level clearance has been accused of stealing hundreds of gold bars worth more than $40m (£29.6m) and stashing them in his home.