In an era marked by rapid technological progress, the pivotal role of Artificial Intelligence (AI) is increasingly evident across various sectors, including local governments. These governmental bodies are progressively leveraging AI technologies to enhance service delivery to their communities, ranging from simple task automation to more complex engineering endeavours. As more local governments adopt AI, it is imperative to understand the functions, implications, and consequences of these advanced technologies. Despite the growing importance of this domain, a significant gap persists within the scholarly discourse. This study aims to bridge this void by exploring the applications of AI technologies within the context of local government service provision. Through this inquiry, it seeks to generate best practice lessons for local government and smart city initiatives. By conducting a comprehensive review of grey literature, we analysed 262 real-world AI implementations across 170 local governments worldwide. The findings underscore several key points: (a) there has been a consistent upward trajectory in the adoption of AI by local governments over the last decade; (b) local governments from China, the US, and the UK are at the forefront of AI adoption; (c) among local government AI technologies, natural language processing and robotic process automation emerge as the most prevalent ones; (d) local governments primarily deploy AI across 28 distinct services; and (e) information management, back-office work, and transportation and traffic management are leading domains in terms of AI adoption. This study enriches the existing body of knowledge by providing an overview of current AI applications within the sphere of local governance. It offers valuable insights for local government and smart city policymakers and decision-makers considering the adoption, expansion, or refinement of AI technologies in urban service provision. Additionally, it highlights the importance of using these insights to guide the successful integration and optimisation of AI in future local government and smart city projects, ensuring they meet the evolving needs of communities.