A former senior CIA official has pleaded guilty to stealing hundreds of gold bars and acquiring real estate in a scam worth more than $40m (£30.2m).