Small planet atmospheres from the ground: state-of-the-art and future perspectives