Pavilion Court, in Cowgate, has been rated 'requires improvement'