Irreducible representations and the Ziegler spectrum over generalised Weyl algebras and related rings