Hundreds joined this elderly dog for a final walk on his favourite beach