Context. Large field-of-view imaging and polarimetry instruments operating at millimetre and sub-millimetre wavelengths are fundamental tools to understand the role of magnetic fields in channelling filament material into prestellar cores, providing unique insight in the physics of galactic star-forming regions. Among other topics, at extra-galactic scales, polarisation observations of Active Galactic Nuclei (AGNs) will allow us to constrain the possible physical conditions of the emitting plasma from the jets and/or explore the physics of dust inside supernova remnants. The kilo-pixel New IRAM KIDs Array 2 (NIKA2) camera, installed today at the Institut de Radioastronomie Millimétrique (IRAM) 30-m telescope, represents one of the best tools available to astronomers to produce simultaneous intensity and polarimetry maps over large fields at 260 GHz (1.15 mm). Aims. The polarisation measurement, in NIKA and NIKA2, is achieved by rapidly modulating the total incoming polarisation. In the end, this allows one to safely isolate the small science signal from the large, un-polarised, and strongly variable, atmospheric background. Methods. The polarisation modulation is achieved by inserting a fast rotating half-wave plate (HWP) in the optical beam. In order to allow wide field-of-view observations, the plate has to be large, with a diameter of 250 mm. The modulation of the polarised signal at 12 Hz also requires the waveplate to be sufficiently light. In addition, this key optical element has to exhibit optimal electromagnetic characteristics in terms of transmission and differential phase-shift. For this purpose, three metamaterial HWPs have been developed using the mesh-filter technology. The knowledge acquired in developing the first two single-band HWPs was used to achieve the more challenging performance requirements of the last dual-band HWP. The first and the third waveplates met the requirements for both the NIKA and NIKA2 instruments. Results. We first illustrate the design, the technical developments, the fabrication, and laboratory characterisation of the three mesh-HWPs. The deployment of two such elements in the NIKA and NIKA2 instruments at the 30-metre telescope is then described. We conclude with representative examples of astrophysical maps integrating polarimetry