The Scottish government minister who racked up an £11,000 data roaming charge on a parliamentary iPad and blamed it on his kids has resigned.