Molecular density functional theory of water describing hydrophobicity at short and long length scales