The architect and TV host developed lasting friendships with many homeowners he worked with on the RTÉ show