Some rainfall will arrive in Northern Ireland this weekend after a recent period of good weather as we enjoy "summer's last hurrah", the Met Office has said.