Use:
SELECT UpdateID, Lodges.LodgeID, Lodge, Update, MAX(Date_Updated) AS Date_Updated
MAX() will ensure you get the most recent date... you don't need DISTINCT because you already have GROUP BY LodgeID which will ensure a unique LodgeID for each row.