Relatives wept as former Ireland rugby star David Tweed was jailed for eight years for a catalogue of child sex abuse.