Scottish Rugby has sacked chief executive Alex Williamson following an independent investigation into his conduct.