Pub ‘used for adult films’ to be flattened and what’s coming in its place