Paul Tweed served as a councillor for over 30 years before a police investigation found he possessed sickening child sex images