A bid by Hereford Rugby Club to host events until 2am at weekends has been approved despite widespread opposition from neighbours and local representatives.