Paul Tweed was the councillor for Litherland ward before a police investigation found he possessed sickening child sex images