Unlocking Location Intelligence: A Survey from Deep Learning to The LLM Era